Editing the Base file
1. Check the specified base file size before uploading. The maximum size of the data file that can be uploaded in Campaign Activity is 15 MB. If the file size is too large, divide it in half and upload the activity as separately.
2. Change the header name in the given excel sheet as shown below.
3. The phoneNumber should contain the country code (+91) with prefix “+” symbol before mobile numbers for all the records otherwise the activity will not be executed.
To add “+”, follow the below steps,
Step 1: Insert one column next to the phoneNumber
Step 2: Enter the formula ="+"&A:A and double click to apply the formula for all records.
Step 3: Copy the entire row and click paste special in the phone number column and remove the column which you have added the formula.
Step 4: Change all the numbers to Stored as text. To do that, Select the entire column and go to Data -> Text to Columns -> Delimited (Next) -> Tab (Next) -> Text (Finish).
Please make sure that numbers in a sheet are being stored as text, Excel lets you know by placing a green triangle in the cell. If not stored as a text, the output in the variable will be like “You have got 50.0 points in your wallet”. To avoid this .0, we need to store all the numbers as text.
